package test;

import jxl.Cell;
import jxl.CellType;
import jxl.write.WritableSheet;

public class DeleteNoNumRow {
	
	public void delete(int totalRows, WritableSheet sheet){
		
		int row = 0;
		
		while(row <= totalRows){
			
			Cell cell = sheet.getCell(0, row);
			
			if(cell.getType() != CellType.EMPTY){
				
				String content = cell.getContents();
				String result = content.substring(0, 1);
				
				if(result.equals("1")){
					
					sheet.removeRow(row);
					row = row - 1;
					
				}
				
				row = row + 1;
				
			}
			
			else break;
			
		}
		
	}

	
	
}
